package dao;

import user.Student;

import java.sql.SQLException;
import java.util.List;

/**
 * @author 长风无言
 */
public interface StudentDao {

    /**
     * description: 获取定量学生
     *
     * @param
     * @return java.util.List<user.Student>
     */
    List<Student> getStudent(String  start,String  end) throws SQLException;

    /**
     * description: 增添学生信息
     *
     * @param student 学生信息
     * @return int
     */
    int addStudent(Student student) throws SQLException;

    /**
     * description:
     *
     * @param num 学号
     * @return int
     */
    int deleteStudent(String num) throws SQLException;

    /**
     * description:
     *
     * @param student 学生信息
     * @return int
     */
    int motifyStudent(Student student) throws SQLException;

    /**
     * description:
     *
     * @param num 学号
     * @return int
     */
    Student findStudentById(String num) throws SQLException;

    /**
     * description:
     *
     * @param name 姓名
     * @return int
     */
    Student findStudentByName(String name) throws SQLException;

    /**
     * description:
     *
     * @param
     * @return int
     */
    int countStudent() throws SQLException;

}
